// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_SALES_DELIVERY_ORDER
// * CreateDate    : 2011/9/27 11:24:18
// * Creater       : CodeSmith
// * LastChangeDate: 2011/9/27 11:24:18
// * LastChanger   : 2011/9/27 11:24:18
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class SalesDeliveryOrderTable : TableInfo
    {
		public const string C_TableName = "SALES_DELIVERY_ORDER";
		
		public const string C_DELIVERY_ORDER_ID = "DELIVERY_ORDER_ID";
		public const string C_DELIVERY_ORDER_CODE = "DELIVERY_ORDER_CODE";
		public const string C_DELIVERY_TYPE = "DELIVERY_TYPE";
		public const string C_DELIVERY_DATE = "DELIVERY_DATE";
		public const string C_CUSTOMER_ID = "CUSTOMER_ID";
		public const string C_DELIVERY_PERSON = "DELIVERY_PERSON";
		public const string C_TRANSPORT_TYPE = "TRANSPORT_TYPE";
		public const string C_RECEIVED_PERSON = "RECEIVED_PERSON";
		public const string C_RECEIVED_PERSON_PHONE = "RECEIVED_PERSON_PHONE";
		public const string C_DELIVERY_PLACE = "DELIVERY_PLACE";
		public const string C_DELIVERY_PLACE_ZIPCODE = "DELIVERY_PLACE_ZIPCODE";
		public const string C_WAREHOUSE_CODE = "WAREHOUSE_CODE";
		public const string C_REMARK = "REMARK";
		public const string C_CREATED_DATE = "CREATED_DATE";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_LAST_MODIFIED_DATE = "LAST_MODIFIED_DATE";
		public const string C_LAST_MODIFIED_BY = "LAST_MODIFIED_BY";
		public const string C_APPROVED_DATE = "APPROVED_DATE";
		public const string C_APPROVED_BY = "APPROVED_BY";
        public const string C_STATUS = "STATUS";
        public const string C_IS_BILLED = "IS_BILLED";
        public const string C_IS_AMOUNT_RECEIVED = "IS_AMOUNT_RECEIVED";
		
		public SalesDeliveryOrderTable()
        {
            _tableName = "SALES_DELIVERY_ORDER";
        }
		
		protected static SalesDeliveryOrderTable _current;
        public static SalesDeliveryOrderTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new SalesDeliveryOrderTable();

            _current.Add(C_DELIVERY_ORDER_ID, new ColumnInfo(C_DELIVERY_ORDER_ID,"DeliveryOrderId", true, typeof(string)));
            _current.Add(C_DELIVERY_ORDER_CODE, new ColumnInfo(C_DELIVERY_ORDER_CODE,"DeliveryOrderCode", false, typeof(string)));
            _current.Add(C_DELIVERY_TYPE, new ColumnInfo(C_DELIVERY_TYPE,"DeliveryType", false, typeof(string)));
            _current.Add(C_DELIVERY_DATE, new ColumnInfo(C_DELIVERY_DATE,"DeliveryDate", false, typeof(DateTime)));
            _current.Add(C_CUSTOMER_ID, new ColumnInfo(C_CUSTOMER_ID,"CustomerId", false, typeof(string)));
            _current.Add(C_DELIVERY_PERSON, new ColumnInfo(C_DELIVERY_PERSON,"DeliveryPerson", false, typeof(string)));
            _current.Add(C_TRANSPORT_TYPE, new ColumnInfo(C_TRANSPORT_TYPE,"TransportType", false, typeof(string)));
            _current.Add(C_RECEIVED_PERSON, new ColumnInfo(C_RECEIVED_PERSON,"ReceivedPerson", false, typeof(string)));
            _current.Add(C_RECEIVED_PERSON_PHONE, new ColumnInfo(C_RECEIVED_PERSON_PHONE,"ReceivedPersonPhone", false, typeof(string)));
            _current.Add(C_DELIVERY_PLACE, new ColumnInfo(C_DELIVERY_PLACE,"DeliveryPlace", false, typeof(string)));
            _current.Add(C_DELIVERY_PLACE_ZIPCODE, new ColumnInfo(C_DELIVERY_PLACE_ZIPCODE,"DeliveryPlaceZipcode", false, typeof(string)));
            _current.Add(C_WAREHOUSE_CODE, new ColumnInfo(C_WAREHOUSE_CODE,"WarehouseCode", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK,"Remark", false, typeof(string)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_LAST_MODIFIED_DATE, new ColumnInfo(C_LAST_MODIFIED_DATE,"LastModifiedDate", false, typeof(DateTime)));
            _current.Add(C_LAST_MODIFIED_BY, new ColumnInfo(C_LAST_MODIFIED_BY,"LastModifiedBy", false, typeof(string)));
            _current.Add(C_APPROVED_DATE, new ColumnInfo(C_APPROVED_DATE,"ApprovedDate", false, typeof(DateTime)));
            _current.Add(C_APPROVED_BY, new ColumnInfo(C_APPROVED_BY,"ApprovedBy", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS, "Status", false, typeof(string)));
            _current.Add(C_IS_BILLED, new ColumnInfo(C_IS_BILLED, "IsBilled", false, typeof(string)));
            _current.Add(C_IS_AMOUNT_RECEIVED, new ColumnInfo(C_IS_AMOUNT_RECEIVED, "IsAmountReceived", false, typeof(string)));
			
		}
		
		public ColumnInfo DELIVERY_ORDER_ID
        {
            get { return this[C_DELIVERY_ORDER_ID]; }
        }
		
		public ColumnInfo DELIVERY_ORDER_CODE
        {
            get { return this[C_DELIVERY_ORDER_CODE]; }
        }
		
		public ColumnInfo DELIVERY_TYPE
        {
            get { return this[C_DELIVERY_TYPE]; }
        }
		
		public ColumnInfo DELIVERY_DATE
        {
            get { return this[C_DELIVERY_DATE]; }
        }
		
		public ColumnInfo CUSTOMER_ID
        {
            get { return this[C_CUSTOMER_ID]; }
        }
		
		public ColumnInfo DELIVERY_PERSON
        {
            get { return this[C_DELIVERY_PERSON]; }
        }
		
		public ColumnInfo TRANSPORT_TYPE
        {
            get { return this[C_TRANSPORT_TYPE]; }
        }
		
		public ColumnInfo RECEIVED_PERSON
        {
            get { return this[C_RECEIVED_PERSON]; }
        }
		
		public ColumnInfo RECEIVED_PERSON_PHONE
        {
            get { return this[C_RECEIVED_PERSON_PHONE]; }
        }
		
		public ColumnInfo DELIVERY_PLACE
        {
            get { return this[C_DELIVERY_PLACE]; }
        }
		
		public ColumnInfo DELIVERY_PLACE_ZIPCODE
        {
            get { return this[C_DELIVERY_PLACE_ZIPCODE]; }
        }
		
		public ColumnInfo WAREHOUSE_CODE
        {
            get { return this[C_WAREHOUSE_CODE]; }
        }
		
		public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo LAST_MODIFIED_DATE
        {
            get { return this[C_LAST_MODIFIED_DATE]; }
        }
		
		public ColumnInfo LAST_MODIFIED_BY
        {
            get { return this[C_LAST_MODIFIED_BY]; }
        }
		
		public ColumnInfo APPROVED_DATE
        {
            get { return this[C_APPROVED_DATE]; }
        }
		
		public ColumnInfo APPROVED_BY
        {
            get { return this[C_APPROVED_BY]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }

        public ColumnInfo IS_BILLED
        {
            get { return this[C_IS_BILLED]; }
        }

        public ColumnInfo IS_AMOUNT_RECEIVED
        {
            get { return this[C_IS_AMOUNT_RECEIVED]; }
        }
	}
}

